<?php if(!defined('IN_INSTALL')) exit("Request Error!"); ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>初始化数据库</title>
<link href="templets/style/install.css" type="text/css" rel="stylesheet" />
<script type="text/javascript" src="templets/js/jquery.min.js"></script>
</head>
<body>
<div class="header">
		<div class="step_area"><!--img src="templets/images/extset.png" /--></div>
</div>
<div class="mainbody">
		<div class="step_sgin"><img src="templets/images/step_sgin_third.png" /></div>
		<h2 class="install_title">正在安装...</h2>
		<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
		<tr>
				<td>
				<div style="height:204px;line-height:24px;overflow:auto;" id="content_area"></div>
				</td>
		</tr>
</table>
</div>
<div class="footer">© 2012 m16888.cn</div>
</body>
</html>
<?php
if((int)$_GET['s'] == 3)
{
    //$dbinfo    = $_POST['dbinfo'];
	//$admininfo = $_POST['admininfo'];
    $conn = @mysql_connect('localhost:3306','root','123456');
    //$conn = @mysql_connect(SAE_MYSQL_HOST_M.':'.SAE_MYSQL_PORT,SAE_MYSQL_USER,SAE_MYSQL_PASS);
	if($conn)
	{
		mysql_select_db('misone_erp_sae', $conn);
        
        //设置数据库状态
		mysql_query("SET NAMES 'utf8', character_set_client=binary, sql_mode='', interactive_timeout=3600;");

		//创建表结构
		$tbdata = '';
		$tbdata = Readf(INSTALL_PATH.'/data/install_struct.txt');
		$querys = explode(';', $tbdata);
		foreach($querys as $q)
		{
			if(trim($q) == '') continue;
			mysql_query(trim($q).';');
		}
		echo '<script>$("#content_area").append("数据库导入完成！<br />");</script>';
        
        $tbdata = "INSERT INTO `misone_currmas` (`id`, `code`, `title`, `flag`, `rate`, `diyinfo`, `orderid`, `posttime`, `status_flg`) VALUES
(1, 'CNY', '人民币', 'Y', 1, 'N;', 1, 1348908529, 'Y'),
(2, 'USD', '美元', 'N', 6.5, 'N;', 2, 1348908547, 'Y');


INSERT INTO `misone_customerclass` (`id`, `parentid`, `parentstr`, `classname`, `orderid`, `status_flg`) VALUES
(1, 0, ',0,', '大客户', 1, 'Y'),
(2, 0, ',0,', '一般客户', 2, 'Y');

INSERT INTO `misone_faccdefault` (`id`, `code`, `title`, `facc_id`, `orderid`, `posttime`, `status_flg`) VALUES
(1, 'INV-AR', '销售-借方应收账款科目', 24, 1, 1349085089, 'Y'),
(2, 'INV-TAX', '销售-销项税', 86, 2, 1349085810, 'Y'),
(3, 'INV-PROFIT', '销售-收入', 159, 3, 1349085842, 'Y'),
(4, 'SINV-AP', '采购-应付账款', 74, 4, 1349102726, 'Y'),
(5, 'SINV-TAX', '采购-进项税', 82, 5, 1349102757, 'Y'),
(6, 'SINV-STK', '采购-库存商品', 35, 6, 1349102793, 'Y'),
(7, 'STKIO-FEE', '其他出入库-损益类科目', 167, 8, 1349708471, 'Y'),
(8, 'STKIO-STK', '其他出入库-存货科目', 35, 9, 1349708514, 'Y'),
(9, 'SINV-FEE', '采购-费用类', 167, 7, 1349839598, 'Y'),
(10, 'INV-STK', '销售-库存商品', 35, 3, 1350009596, 'Y'),
(11, 'BANK', '现金或银行默认科目', 6, 11, 1350009651, 'Y'),
(12, 'PRECOLLECTED', '预收科目', 75, 12, 1350009806, 'Y'),
(13, 'PREPAID', '预付科目', 27, 13, 1350009854, 'Y'),
(14, 'EGOL', '汇兑损益(Exchange Gains Or Losses)', 169, 14, 1350010478, 'Y'),
(15, 'INV-FEE', '销售成本', 164, 3, 1350446101, 'Y'),
(16, 'SINV-DIFF', '采购退货成本差异', 164, 7, 1350453749, 'Y');


INSERT INTO `misone_faccmas` (`id`, `parentid`, `parentstr`, `code`, `title`, `note`, `diyinfo`, `orderid`, `posttime`, `status_flg`) VALUES
(1, 0, ',0,', '1000', '资产', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 1, 0, 'Y'),
(2, 0, ',0,', '2000', '负债', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 2, 0, 'Y'),
(3, 0, ',0,', '3000', '所有者权益', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 3, 0, 'Y'),
(4, 0, ',0,', '4000', '成本', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 4, 0, 'Y'),
(5, 0, ',0,', '5000', '损益', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 5, 0, 'Y'),
(6, 1, ',0,1,', '1001', '现金', '', 'a:6:{s:4:\"bank\";s:1:\"Y\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 6, 0, 'Y'),
(7, 1, ',0,1,', '1002', '银行存款', '', 'a:6:{s:4:\"bank\";s:1:\"Y\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 7, 0, 'Y'),
(8, 1, ',0,1,', '1009', '其他货币资金', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 8, 0, 'Y'),
(9, 8, ',0,1,8,', '100901', '外埠存款', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 9, 0, 'Y'),
(10, 8, ',0,1,8,', '100902', '银行本票存款', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 10, 0, 'Y'),
(11, 8, ',0,1,8,', '100903', '银行汇票存款', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 11, 0, 'Y'),
(12, 8, ',0,1,8,', '100904', '信用卡', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 12, 0, 'Y'),
(13, 8, ',0,1,8,', '100905', '信用证保证金', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 13, 0, 'Y'),
(14, 8, ',0,1,8,', '100906', '存出投资款', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 14, 0, 'Y'),
(15, 1, ',0,1,', '1101', '短期投资', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 15, 0, 'Y'),
(16, 15, ',0,1,15,', '110101', '股票', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 16, 0, 'Y'),
(17, 15, ',0,1,15,', '110102', '债券', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 17, 0, 'Y'),
(18, 15, ',0,1,15,', '110103', '基金', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 18, 0, 'Y'),
(19, 15, ',0,1,15,', '110110', '其他', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 19, 0, 'Y'),
(20, 1, ',0,1,', '1102', '短期投资跌价准备', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 20, 0, 'Y'),
(21, 1, ',0,1,', '1111', '应收票据', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 21, 0, 'Y'),
(22, 1, ',0,1,', '1121', '应收股利', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 22, 0, 'Y'),
(23, 1, ',0,1,', '1122', '应收利息', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 23, 0, 'Y'),
(24, 1, ',0,1,', '1131', '应收账款', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"Y\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 24, 0, 'Y'),
(25, 1, ',0,1,', '1133', '其他应收款', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 25, 0, 'Y'),
(26, 1, ',0,1,', '1141', '坏账准备', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 26, 0, 'Y'),
(27, 1, ',0,1,', '1151', '预付账款', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"Y\";s:6:\"profit\";s:1:\"N\";}', 27, 0, 'Y'),
(28, 1, ',0,1,', '1161', '应收补贴款', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 28, 0, 'Y'),
(29, 1, ',0,1,', '1201', '物资采购', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 29, 0, 'Y'),
(30, 1, ',0,1,', '1211', '原材料', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 30, 0, 'Y'),
(31, 1, ',0,1,', '1221', '包装物', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 31, 0, 'Y'),
(32, 1, ',0,1,', '1231', '低值易耗品', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 32, 0, 'Y'),
(33, 1, ',0,1,', '1232', '材料成本差异', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 33, 0, 'Y'),
(34, 1, ',0,1,', '1241', '自制半成品', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 34, 0, 'Y'),
(35, 1, ',0,1,', '1243', '库存商品', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 35, 0, 'Y'),
(36, 1, ',0,1,', '1244', '商品进销差价', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 36, 0, 'Y'),
(37, 1, ',0,1,', '1251', '委托加工物资', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 37, 0, 'Y'),
(38, 1, ',0,1,', '1261', '委托代销商品', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 38, 0, 'Y'),
(39, 1, ',0,1,', '1271', '受托代销商品', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 39, 0, 'Y'),
(40, 1, ',0,1,', '1281', '存货跌价准备', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 40, 0, 'Y'),
(41, 1, ',0,1,', '1291', '分期收款发出商品', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 41, 0, 'Y'),
(42, 1, ',0,1,', '1301', '待摊费用', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 42, 0, 'Y'),
(43, 1, ',0,1,', '1401', '长期股权投资', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 43, 0, 'Y'),
(44, 43, ',0,1,43,', '140101', '股票投资', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 44, 0, 'Y'),
(45, 43, ',0,1,43,', '140102', '其他股权投资', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 45, 0, 'Y'),
(46, 1, ',0,1,', '1402', '长期债权投资', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 46, 0, 'Y'),
(47, 46, ',0,1,46,', '140201', '债券投资', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 47, 0, 'Y'),
(48, 46, ',0,1,46,', '140202', '其他债权投资', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 48, 0, 'Y'),
(49, 1, ',0,1,', '1421', '长期投资减值准备', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 49, 0, 'Y'),
(50, 1, ',0,1,', '1431', '委托贷款', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 50, 0, 'Y'),
(51, 50, ',0,1,50,', '143101', '本金', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 51, 0, 'Y'),
(52, 50, ',0,1,50,', '143102', '利息', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 52, 0, 'Y'),
(53, 50, ',0,1,50,', '143103', '减值准备', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 53, 0, 'Y'),
(54, 1, ',0,1,', '1501', '固定资产', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 54, 0, 'Y'),
(55, 1, ',0,1,', '1502', '累计折旧', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 55, 0, 'Y'),
(56, 1, ',0,1,', '1505', '固定资产减值准备', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 56, 0, 'Y'),
(57, 1, ',0,1,', '1601', '工程物资', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 57, 0, 'Y'),
(58, 57, ',0,1,57,', '160101', '专用材料', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 58, 0, 'Y'),
(59, 57, ',0,1,57,', '160102', '专用设备', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 59, 0, 'Y'),
(60, 57, ',0,1,57,', '160103', '预付大型设备款', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 60, 0, 'Y'),
(61, 57, ',0,1,57,', '160104', '为生产准备的工具及器具', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 61, 0, 'Y'),
(62, 1, ',0,1,', '1603', '在建工程', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 62, 0, 'Y'),
(63, 1, ',0,1,', '1605', '在建工程减值准备', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 63, 0, 'Y'),
(64, 1, ',0,1,', '1701', '固定资产清理', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 64, 0, 'Y'),
(65, 1, ',0,1,', '1801', '无形资产', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 65, 0, 'Y'),
(66, 1, ',0,1,', '1805', '无形资产减值准备', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 66, 0, 'Y'),
(67, 1, ',0,1,', '1815', '未确认融资费用', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 67, 0, 'Y'),
(68, 1, ',0,1,', '1901', '长期待摊费用', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 68, 0, 'Y'),
(69, 1, ',0,1,', '1911', '待处理财产损溢', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 69, 0, 'Y'),
(70, 69, ',0,1,69,', '191101', '待处理流动资产损溢', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 70, 0, 'Y'),
(71, 69, ',0,1,69,', '191102', '待处理固定资产损溢', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 71, 0, 'Y'),
(72, 2, ',0,2,', '2101', '短期借款', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 72, 0, 'Y'),
(73, 2, ',0,2,', '2111', '应付票据', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 73, 0, 'Y'),
(74, 2, ',0,2,', '2121', '应付账款', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"Y\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 74, 0, 'Y'),
(75, 2, ',0,2,', '2131', '预收账款', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"Y\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 75, 0, 'Y'),
(76, 2, ',0,2,', '2141', '代销商品款', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 76, 0, 'Y'),
(77, 2, ',0,2,', '2151', '应付工资', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 77, 0, 'Y'),
(78, 2, ',0,2,', '2153', '应付福利费', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 78, 0, 'Y'),
(79, 2, ',0,2,', '2161', '应付股利', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 79, 0, 'Y'),
(80, 2, ',0,2,', '2171', '应交税金', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 80, 0, 'Y'),
(81, 80, ',0,2,80,', '217101', '应交增值税', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 81, 0, 'Y'),
(82, 81, ',0,2,80,81,', '21710101', '进项税额', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 82, 0, 'Y'),
(83, 81, ',0,2,80,81,', '21710102', '已交税金', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 83, 0, 'Y'),
(84, 81, ',0,2,80,81,', '21710103', '转出未交增值税', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 84, 0, 'Y'),
(85, 81, ',0,2,80,81,', '21710104', '减免税款', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 85, 0, 'Y'),
(86, 81, ',0,2,80,81,', '21710105', '销项税额', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 86, 0, 'Y'),
(87, 81, ',0,2,80,81,', '21710106', '出口退税', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 87, 0, 'Y'),
(88, 81, ',0,2,80,81,', '21710107', '进项税额转出', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 88, 0, 'Y'),
(89, 81, ',0,2,80,81,', '21710108', '出口抵减内销产品应纳税额', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 89, 0, 'Y'),
(90, 81, ',0,2,80,81,', '21710109', '转出多交增值税', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 90, 0, 'Y'),
(91, 80, ',0,2,80,', '217102', '未交增值税', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 91, 0, 'Y'),
(92, 80, ',0,2,80,', '217103', '应交营业税', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 92, 0, 'Y'),
(93, 80, ',0,2,80,', '217104', '应交消费税', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 93, 0, 'Y'),
(94, 80, ',0,2,80,', '217105', '应交资源税', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 94, 0, 'Y'),
(95, 80, ',0,2,80,', '217106', '应交所得税', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 95, 0, 'Y'),
(96, 80, ',0,2,80,', '217107', '应交土地增值税', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 96, 0, 'Y'),
(97, 80, ',0,2,80,', '217108', '应交城市维护建设税', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 97, 0, 'Y'),
(98, 80, ',0,2,80,', '217109', '应交房产税', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 98, 0, 'Y'),
(99, 80, ',0,2,80,', '217110', '应交土地使用税', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 99, 0, 'Y'),
(100, 80, ',0,2,80,', '217111', '应交车船使用税', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 100, 0, 'Y'),
(101, 80, ',0,2,80,', '217112', '应交个人所得税', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 101, 0, 'Y'),
(102, 80, ',0,2,80,', '217113', '教育附加', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 102, 0, 'Y'),
(103, 80, ',0,2,80,', '217114', '地方教育发展费', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 103, 0, 'Y'),
(104, 2, ',0,2,', '2176', '其他应交款', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 104, 0, 'Y'),
(105, 2, ',0,2,', '2181', '其他应付款', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 105, 0, 'Y'),
(106, 2, ',0,2,', '2191', '预提费用', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 106, 0, 'Y'),
(107, 2, ',0,2,', '2201', '待转资产价值', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 107, 0, 'Y'),
(108, 2, ',0,2,', '2211', '预计负债', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 108, 0, 'Y'),
(109, 2, ',0,2,', '2301', '长期借款', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 109, 0, 'Y'),
(110, 109, ',0,2,109,', '230101', '借款本金', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 110, 0, 'Y'),
(111, 109, ',0,2,109,', '230102', '借款利息', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 111, 0, 'Y'),
(112, 2, ',0,2,', '2311', '应付债券', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 112, 0, 'Y'),
(113, 112, ',0,2,112,', '231101', '债券面值', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 113, 0, 'Y'),
(114, 112, ',0,2,112,', '231102', '债券溢价', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 114, 0, 'Y'),
(115, 112, ',0,2,112,', '231103', '债券折价', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 115, 0, 'Y'),
(116, 112, ',0,2,112,', '231104', '应计利息', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 116, 0, 'Y'),
(117, 2, ',0,2,', '2321', '长期应付款', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 117, 0, 'Y'),
(118, 2, ',0,2,', '2331', '专项应付款', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 118, 0, 'Y'),
(119, 2, ',0,2,', '2341', '递延税款', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 119, 0, 'Y'),
(120, 3, ',0,3,', '3101', '实收资本（或股本）', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 120, 0, 'Y'),
(121, 3, ',0,3,', '3103', '已归还投资', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 121, 0, 'Y'),
(122, 3, ',0,3,', '3111', '资本公积', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 122, 0, 'Y'),
(123, 122, ',0,3,122,', '311101', '资本（或股本）溢价', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 123, 0, 'Y'),
(124, 122, ',0,3,122,', '311102', '接受捐赠非现金资产准备', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 124, 0, 'Y'),
(125, 122, ',0,3,122,', '311103', '接受现金捐赠', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 125, 0, 'Y'),
(126, 122, ',0,3,122,', '311104', '股权投资准备', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 126, 0, 'Y'),
(127, 122, ',0,3,122,', '311105', '拨款转入', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 127, 0, 'Y'),
(128, 122, ',0,3,122,', '311106', '外币资本折算差额', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 128, 0, 'Y'),
(129, 122, ',0,3,122,', '311107', '其他资本公积', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 129, 0, 'Y'),
(130, 3, ',0,3,', '3121', '盈余公积', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 130, 0, 'Y'),
(131, 130, ',0,3,130,', '312101', '法定盈余公积', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 131, 0, 'Y'),
(132, 130, ',0,3,130,', '312102', '任意盈余公积', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 132, 0, 'Y'),
(133, 130, ',0,3,130,', '312103', '法定公益金', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 133, 0, 'Y'),
(134, 130, ',0,3,130,', '312104', '储备基金', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 134, 0, 'Y'),
(135, 130, ',0,3,130,', '312105', '企业发展基金', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 135, 0, 'Y'),
(136, 130, ',0,3,130,', '312106', '利润归还投资', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 136, 0, 'Y'),
(137, 3, ',0,3,', '3131', '本年利润', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"Y\";s:6:\"credit\";s:1:\"Y\";}', 137, 0, 'Y'),
(138, 3, ',0,3,', '3141', '利润分配', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 138, 0, 'Y'),
(139, 138, ',0,3,138,', '314101', '其他转入', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 139, 0, 'Y'),
(140, 138, ',0,3,138,', '314102', '提取法定盈余公积', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 140, 0, 'Y'),
(141, 138, ',0,3,138,', '314103', '提取法定公益金', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 141, 0, 'Y'),
(142, 138, ',0,3,138,', '314104', '提取储备基金', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 142, 0, 'Y'),
(143, 138, ',0,3,138,', '314105', '提取企业发展基金', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 143, 0, 'Y'),
(144, 138, ',0,3,138,', '314106', '提取职工奖励及福利基金', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 144, 0, 'Y'),
(145, 138, ',0,3,138,', '314107', '利润归还投资', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 145, 0, 'Y'),
(146, 138, ',0,3,138,', '314108', '应付优先股股利', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 146, 0, 'Y'),
(147, 138, ',0,3,138,', '314109', '提取任意盈余公积', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 147, 0, 'Y'),
(148, 138, ',0,3,138,', '314110', '应付普通股股利', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 148, 0, 'Y'),
(149, 138, ',0,3,138,', '314111', '转作资本（或股本）的普通股股利', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 149, 0, 'Y'),
(150, 138, ',0,3,138,', '314115', '未分配利润', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 150, 0, 'Y'),
(151, 4, ',0,4,', '4101', '生产成本', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 151, 0, 'Y'),
(152, 151, ',0,4,148,', '410101', '基本生产成本', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 152, 0, 'Y'),
(153, 152, ',0,4,148,152,', '41010101', '直接材料费用', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 153, 0, 'Y'),
(154, 152, ',0,4,148,152,', '41010102', '直接人工费用', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 154, 0, 'Y'),
(155, 151, ',0,4,148,', '410102', '辅助生产成本', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 155, 0, 'Y'),
(156, 4, ',0,4,', '4105', '制造费用', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 156, 0, 'Y'),
(157, 4, ',0,4,', '4107', '劳务成本', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 157, 0, 'Y'),
(158, 4, ',0,4,', '4108', '研发支出', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 158, 0, 'Y'),
(159, 5, ',0,5,', '5101', '主营业务收入', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 159, 0, 'Y'),
(160, 5, ',0,5,', '5102', '其他业务收入', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 160, 0, 'Y'),
(161, 5, ',0,5,', '5201', '投资收益', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 161, 0, 'Y'),
(162, 5, ',0,5,', '5203', '补贴收入', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 162, 0, 'Y'),
(163, 5, ',0,5,', '5301', '营业外收入', '', 'a:7:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";s:6:\"credit\";s:1:\"Y\";}', 163, 0, 'Y'),
(164, 5, ',0,5,', '5401', '主营业务成本', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 164, 0, 'Y'),
(165, 5, ',0,5,', '5402', '主营业务税金及附加', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 165, 0, 'Y'),
(166, 5, ',0,5,', '5405', '其他业务支出', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 166, 0, 'Y'),
(167, 5, ',0,5,', '5501', '营业费用', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 167, 0, 'Y'),
(168, 5, ',0,5,', '5502', '管理费用', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 168, 0, 'Y'),
(169, 5, ',0,5,', '5503', '财务费用', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 169, 0, 'Y'),
(170, 5, ',0,5,', '5601', '营业外支出', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 170, 0, 'Y'),
(171, 5, ',0,5,', '5701', '所得税', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 171, 0, 'Y'),
(172, 5, ',0,5,', '5801', '以前年度损益调整', '', 'a:6:{s:4:\"bank\";s:1:\"N\";s:6:\"arctrl\";s:1:\"N\";s:6:\"apctrl\";s:1:\"N\";s:12:\"precollected\";s:1:\"N\";s:7:\"prepaid\";s:1:\"N\";s:6:\"profit\";s:1:\"N\";}', 172, 0, 'Y');

INSERT INTO `misone_fiscalyp` (`id`, `f_year`, `f_period`, `title`, `flag`, `diyinfo`, `posttime`, `status_flg`) VALUES
(1, 2011, 1, '2011年1月', '', '', 1348911983, '0'),
(2, 2011, 2, '2011年2月', '', '', 1348911983, '0'),
(3, 2011, 3, '2011年3月', '', '', 1348911983, '0'),
(4, 2011, 4, '2011年4月', '', '', 1348911983, '0'),
(5, 2011, 5, '2011年5月', '', '', 1348911983, '0'),
(6, 2011, 6, '2011年6月', '', '', 1348911983, '0'),
(7, 2011, 7, '2011年7月', '', '', 1348911983, '0'),
(8, 2011, 8, '2011年8月', '', '', 1348911983, '0'),
(9, 2011, 9, '2011年9月', '', '', 1348911983, '0'),
(10, 2011, 10, '2011年10月', '', '', 1348911983, '0'),
(11, 2011, 11, '2011年11月', '', '', 1348911983, '0'),
(12, 2011, 12, '2011年12月', '', '', 1348911983, '0'),
(13, 2012, 1, '2012年1月', '', '', 1348912048, '0'),
(14, 2012, 2, '2012年2月', '', '', 1348912048, '0'),
(15, 2012, 3, '2012年3月', '', '', 1348912048, '0'),
(16, 2012, 4, '2012年4月', '', '', 1348912048, '0'),
(17, 2012, 5, '2012年5月', '', '', 1348912048, '0'),
(18, 2012, 6, '2012年6月', '', '', 1348912048, '0'),
(19, 2012, 7, '2012年7月', '', '', 1348912048, '0'),
(20, 2012, 8, '2012年8月', '', '', 1348912048, '0'),
(21, 2012, 9, '2012年9月', '', '', 1348912048, '1'),
(22, 2012, 10, '2012年10月', '', '', 1348912048, '2'),
(23, 2012, 11, '2012年11月', '', '', 1348912048, '0'),
(24, 2012, 12, '2012年12月', '', '', 1348912048, '0');

INSERT INTO `misone_iotype` (`id`, `title`, `flag`, `keywords`, `diyinfo`, `orderid`, `posttime`, `status_flg`) VALUES
(1, '系统初始化入库', 'IN', '', 'N;', 1, 1348893393, 'Y'),
(2, '客商赠送入库', 'IN', '', 'N;', 2, 1348893482, 'Y'),
(3, '客商赠送出库', 'OUT', '', 'N;', 3, 1348893524, 'Y'),
(4, '盘盈', 'IN', '', 'N;', 4, 1348893543, 'Y'),
(5, '盘亏', 'OUT', '', 'N;', 5, 1348893554, 'Y'),
(6, '客户返修入库', 'IN', '', 'N;', 6, 1350548880, 'Y'),
(7, '客户返修归还出库', 'OUT', '', 'N;', 7, 1350548899, 'Y');


INSERT INTO `misone_node` (`id`, `name`, `title`, `status`, `remark`, `sort`, `pid`, `level`) VALUES
(1, 'Erp', 'ERP主系统', 1, ',0,', 0, 0, 1),
(10001, 'Index', '系统管理', 1, ',0,1,', 1, 1, 2),
(10002, 'Power', '用户组及权限', 1, ',0,1,', 2, 1, 2),
(10003, 'Stk', '商品管理', 1, ',0,1,', 3, 1, 2),
(10004, 'Warehouse', '仓库管理', 1, ',0,1,', 4, 1, 2),
(10005, 'Customer', '客户管理', 1, ',0,1,', 5, 1, 2),
(10006, 'Supplier', '供应商管理', 1, ',0,1,', 6, 1, 2),
(10007, 'Sales', '销售模块', 1, ',0,1,', 7, 1, 2),
(10008, 'Purchasing', '采购模块', 1, ',0,1,', 8, 1, 2),
(10009, 'Stkio', '其他库存进出', 1, ',0,1,', 9, 1, 2),
(10010, 'Finance', '财务模块', 1, ',0,1,', 10, 1, 2),
(10011, 'Info', '其他信息管理', 0, ',0,1,', 11, 1, 2),
(10012, 'index', '系统欢迎界面', 1, ',0,1,10001,', 101, 10001, 3),
(10013, 'edit_password', '修改密码界面', 1, ',0,1,10001,', 102, 10001, 3),
(10014, 'edit_password_save', '修改密码保存', 1, ',0,1,10001,', 103, 10001, 3),
(10015, 'account_add', '增加用户界面', 1, ',0,1,10001,', 104, 10001, 3),
(10016, 'account_add_save', '增加用户保存', 1, ',0,1,10001,', 105, 10001, 3),
(10017, 'account_list', '查看用户列表', 1, ',0,1,10001,', 106, 10001, 3),
(10018, 'account_edit', '编辑用户界面', 1, ',0,1,10001,', 107, 10001, 3),
(10019, 'account_edit_save', '编辑用户保存', 1, ',0,1,10001,', 108, 10001, 3),
(10020, 'account_del', '删除用户', 1, ',0,1,10001,', 109, 10001, 3),
(10021, 'account_popup', '打开用户弹窗', 1, ',0,1,10001,', 110, 10001, 3),
(10022, 'web_config', '系统配置界面', 1, ',0,1,10001,', 111, 10001, 3),
(10023, 'web_config_add_save', '新增系统配置项', 1, ',0,1,10001,', 112, 10001, 3),
(10024, 'web_config_save', '保存系统配置修改', 1, ',0,1,10001,', 113, 10001, 3),
(10025, 'web_config_del', '删除系统配置项', 1, ',0,1,10001,', 114, 10001, 3),
(10026, 'uploadbox', '上传界面', 1, ',0,1,10001,', 115, 10001, 3),
(10027, 'upload_save', '上传保存', 1, ',0,1,10001,', 116, 10001, 3),
(10028, 'today', '今日看板', 1, ',0,1,10001,', 117, 10001, 3),
(10029, 'help', '帮助界面', 1, ',0,1,10001,', 118, 10001, 3),
(10030, 'about', '关于界面', 1, ',0,1,10001,', 119, 10001, 3),
(10031, 'index', '用户组和权限首页', 1, ',0,1,10002,', 122, 10002, 3),
(10032, 'node_list', '查看模块列表', 1, ',0,1,10002,', 123, 10002, 3),
(10033, 'node_add', '新增模块界面', 1, ',0,1,10002,', 124, 10002, 3),
(10034, 'node_add_save', '新增模块保存', 1, ',0,1,10002,', 125, 10002, 3),
(10035, 'node_edit', '编辑模块界面', 1, ',0,1,10002,', 126, 10002, 3),
(10036, 'node_edit_save', '编辑模块保存', 1, ',0,1,10002,', 127, 10002, 3),
(10037, 'node_del', '删除模块项', 1, ',0,1,10002,', 128, 10002, 3),
(10038, 'get_parentstr', '公用-读取级层关系', 1, ',0,1,10002,', 130, 10002, 3),
(10039, 'set_parentstr', '公用-设置级层关系', 1, ',0,1,10002,', 131, 10002, 3),
(10040, 'get_node_list', '公用-读取模块到下拉框', 1, ',0,1,10002,', 132, 10002, 3),
(10041, 'role_list', '查看用户组列表', 1, ',0,1,10002,', 134, 10002, 3),
(10042, 'role_add', '新增用户组界面', 1, ',0,1,10002,', 135, 10002, 3),
(10043, 'role_add_save', '新增用户组保存', 1, ',0,1,10002,', 136, 10002, 3),
(10044, 'role_edit', '编辑用户组界面', 1, ',0,1,10002,', 137, 10002, 3),
(10045, 'role_edit_save', '编辑用户组保存', 1, ',0,1,10002,', 138, 10002, 3),
(10046, 'role_del', '删除用户组', 1, ',0,1,10002,', 139, 10002, 3),
(10047, 'access', '配置用户组权限界面', 1, ',0,1,10002,', 141, 10002, 3),
(10048, 'access_save', '配置用户组权限保存', 1, ',0,1,10002,', 142, 10002, 3),
(10049, 'access_clear', '清除用户组权限', 1, ',0,1,10002,', 143, 10002, 3),
(10050, 'role_user', '设置用户组成员界面', 1, ',0,1,10002,', 145, 10002, 3),
(10051, 'role_user_save', '设置用户组成员保存', 1, ',0,1,10002,', 146, 10002, 3),
(10052, 'user_clear', '清除用户组成员', 1, ',0,1,10002,', 147, 10002, 3),
(10053, 'index', '商品管理首页', 1, ',0,1,10003,', 150, 10003, 3),
(10054, 'class_list', '查看类别列表', 1, ',0,1,10003,', 151, 10003, 3),
(10055, 'class_add', '新增类别界面', 1, ',0,1,10003,', 152, 10003, 3),
(10056, 'class_add_save', '新增类别保存', 1, ',0,1,10003,', 153, 10003, 3),
(10057, 'class_edit', '编辑类别界面', 1, ',0,1,10003,', 154, 10003, 3),
(10058, 'class_edit_save', '编辑类别保存', 1, ',0,1,10003,', 155, 10003, 3),
(10059, 'class_del', '删除类别', 1, ',0,1,10003,', 156, 10003, 3),
(10060, 'brand_list', '查看品牌列表', 1, ',0,1,10003,', 158, 10003, 3),
(10061, 'brand_add', '新增品牌界面', 1, ',0,1,10003,', 159, 10003, 3),
(10062, 'brand_add_save', '新增品牌保存', 1, ',0,1,10003,', 160, 10003, 3),
(10063, 'brand_edit', '编辑品牌界面', 1, ',0,1,10003,', 161, 10003, 3),
(10064, 'brand_edit_save', '编辑品牌保存', 1, ',0,1,10003,', 162, 10003, 3),
(10065, 'brand_del', '删除品牌', 1, ',0,1,10003,', 163, 10003, 3),
(10066, 'data_list', '查看商品列表', 1, ',0,1,10003,', 165, 10003, 3),
(10067, 'data_list_rec', '查看商品回收站', 1, ',0,1,10003,', 166, 10003, 3),
(10068, 'data_add', '新增商品界面', 1, ',0,1,10003,', 167, 10003, 3),
(10069, 'data_add_save', '新增商品保存', 1, ',0,1,10003,', 168, 10003, 3),
(10070, 'data_edit', '编辑商品界面', 1, ',0,1,10003,', 169, 10003, 3),
(10071, 'data_edit_save', '编辑商品保存', 1, ',0,1,10003,', 170, 10003, 3),
(10072, 'data_del', '删除商品到回收站', 1, ',0,1,10003,', 171, 10003, 3),
(10073, 'data_del_todo', '彻底删除商品', 1, ',0,1,10003,', 172, 10003, 3),
(10074, 'data_del_undo', '从回收站恢复商品', 1, ',0,1,10003,', 173, 10003, 3),
(10075, 'data_status_to_y', '批量启用商品', 1, ',0,1,10003,', 174, 10003, 3),
(10076, 'data_status_to_n', '批量禁用商品', 1, ',0,1,10003,', 175, 10003, 3),
(10077, 'data_move_byid', '批量移动选中的商品到新类别', 1, ',0,1,10003,', 176, 10003, 3),
(10078, 'data_move_byclass', '批量按类别移动商品', 1, ',0,1,10003,', 177, 10003, 3),
(10079, 'get_parentstr', '公用读取层级关系', 1, ',0,1,10003,', 179, 10003, 3),
(10080, 'set_parentstr', '公用设置层级关系', 1, ',0,1,10003,', 180, 10003, 3),
(10081, 'get_class_list', '读取类别下拉数据', 1, ',0,1,10003,', 181, 10003, 3),
(10082, 'get_brand_list', '读取品牌下拉数据', 1, ',0,1,10003,', 182, 10003, 3),
(10083, 'stkmas_popup', '打开商品弹窗', 1, ',0,1,10003,', 183, 10003, 3),
(10084, 'index', '仓库管理首页', 1, ',0,1,10004,', 186, 10004, 3),
(10085, 'whmas_list', '查看仓库列表', 1, ',0,1,10004,', 187, 10004, 3),
(10086, 'whmas_add', '新增仓库界面', 1, ',0,1,10004,', 188, 10004, 3),
(10087, 'whmas_add_save', '新增仓库保存', 1, ',0,1,10004,', 189, 10004, 3),
(10088, 'whmas_edit', '编辑仓库界面', 1, ',0,1,10004,', 190, 10004, 3),
(10089, 'whmas_edit_save', '编辑仓库保存', 1, ',0,1,10004,', 191, 10004, 3),
(10090, 'whmas_del', '删除仓库', 1, ',0,1,10004,', 192, 10004, 3),
(10091, 'whmas_status_to_y', '批量启用仓库', 1, ',0,1,10004,', 193, 10004, 3),
(10092, 'whmas_status_to_n', '批量禁用仓库', 1, ',0,1,10004,', 194, 10004, 3),
(10093, 'whmas_popup', '打开仓库弹窗', 1, ',0,1,10004,', 195, 10004, 3),
(10094, 'iotype_list', '查看出入库类型列表', 1, ',0,1,10004,', 197, 10004, 3),
(10095, 'iotype_add', '新增出入库类型界面', 1, ',0,1,10004,', 198, 10004, 3),
(10096, 'iotype_add_save', '新增出入库类型保存', 1, ',0,1,10004,', 199, 10004, 3),
(10097, 'iotype_edit', '编辑出入库类型界面', 1, ',0,1,10004,', 200, 10004, 3),
(10098, 'iotype_edit_save', '编辑出入库类型保存', 1, ',0,1,10004,', 201, 10004, 3),
(10099, 'iotype_del', '删除出入库类型', 1, ',0,1,10004,', 202, 10004, 3),
(10100, 'iotype_status_to_y', '批量启用出入库类型', 1, ',0,1,10004,', 203, 10004, 3),
(10101, 'iotype_status_to_n', '批量禁用出入库类型', 1, ',0,1,10004,', 204, 10004, 3),
(10102, 'iotype_popup', '打开出入库类型弹窗', 1, ',0,1,10004,', 205, 10004, 3),
(10103, 'stk_detail', '查看库存分布明细', 1, ',0,1,10004,', 207, 10004, 3),
(10104, 'stk_search', '查看实时库存', 1, ',0,1,10004,', 208, 10004, 3),
(10105, 'stk_track', '查看货物凭证', 1, ',0,1,10004,', 209, 10004, 3),
(10106, 'stk_qtylow', '查看库存下限报警', 1, ',0,1,10004,', 210, 10004, 3),
(10107, 'stk_qtyhigh', '查看库存上限报警', 1, ',0,1,10004,', 211, 10004, 3),
(10108, 'index', '客户管理首页', 1, ',0,1,10005,', 214, 10005, 3),
(10109, 'class_list', '查看客户分类', 1, ',0,1,10005,', 215, 10005, 3),
(10110, 'class_add', '新增客户分类界面', 1, ',0,1,10005,', 216, 10005, 3),
(10111, 'class_add_save', '新增客户分类保存', 1, ',0,1,10005,', 217, 10005, 3),
(10112, 'class_edit', '编辑客户分类界面', 1, ',0,1,10005,', 218, 10005, 3),
(10113, 'class_edit_save', '编辑客户分类保存', 1, ',0,1,10005,', 219, 10005, 3),
(10114, 'class_del', '删除客户分类', 1, ',0,1,10005,', 220, 10005, 3),
(10115, 'data_list', '查看客户列表', 1, ',0,1,10005,', 222, 10005, 3),
(10116, 'data_list_rec', '查看客户回收站', 1, ',0,1,10005,', 223, 10005, 3),
(10117, 'data_add', '新增客户界面', 1, ',0,1,10005,', 224, 10005, 3),
(10118, 'data_add_save', '新增客户保存', 1, ',0,1,10005,', 225, 10005, 3),
(10119, 'data_edit', '编辑客户界面', 1, ',0,1,10005,', 226, 10005, 3),
(10120, 'data_edit_save', '编辑客户保存', 1, ',0,1,10005,', 227, 10005, 3),
(10121, 'data_del', '删除客户到回收站', 1, ',0,1,10005,', 228, 10005, 3),
(10122, 'data_del_todo', '从回收站删除客户', 1, ',0,1,10005,', 229, 10005, 3),
(10123, 'data_del_undo', '从回收站恢复客户', 1, ',0,1,10005,', 230, 10005, 3),
(10124, 'data_status_to_y', '批量启用客户', 1, ',0,1,10005,', 231, 10005, 3),
(10125, 'data_status_to_n', '批量禁用客户', 1, ',0,1,10005,', 232, 10005, 3),
(10126, 'data_move_byid', '批量转移选中客户的类别', 1, ',0,1,10005,', 233, 10005, 3),
(10127, 'data_move_byclass', '批量按类别转移到新类别', 1, ',0,1,10005,', 234, 10005, 3),
(10128, 'get_parentstr', '公用读取层级关系', 1, ',0,1,10005,', 236, 10005, 3),
(10129, 'set_parentstr', '公用设置层级关系', 1, ',0,1,10005,', 237, 10005, 3),
(10130, 'get_class_list', '读取类别下拉数据', 1, ',0,1,10005,', 238, 10005, 3),
(10131, 'customer_popup', '打开客户弹窗', 1, ',0,1,10005,', 239, 10005, 3),
(10132, 'index', '供应商管理首页', 1, ',0,1,10006,', 242, 10006, 3),
(10133, 'class_list', '查看供应商分类', 1, ',0,1,10006,', 243, 10006, 3),
(10134, 'class_add', '新增供应商分类界面', 1, ',0,1,10006,', 244, 10006, 3),
(10135, 'class_add_save', '新增供应商分类保存', 1, ',0,1,10006,', 245, 10006, 3),
(10136, 'class_edit', '编辑供应商分类界面', 1, ',0,1,10006,', 246, 10006, 3),
(10137, 'class_edit_save', '编辑供应商分类保存', 1, ',0,1,10006,', 247, 10006, 3),
(10138, 'class_del', '删除供应商分类', 1, ',0,1,10006,', 248, 10006, 3),
(10139, 'data_list', '查看供应商列表', 1, ',0,1,10006,', 250, 10006, 3),
(10140, 'data_list_rec', '查看供应商回收站', 1, ',0,1,10006,', 251, 10006, 3),
(10141, 'data_add', '新增供应商界面', 1, ',0,1,10006,', 252, 10006, 3),
(10142, 'data_add_save', '新增供应商保存', 1, ',0,1,10006,', 253, 10006, 3),
(10143, 'data_edit', '编辑供应商界面', 1, ',0,1,10006,', 254, 10006, 3),
(10144, 'data_edit_save', '编辑供应商保存', 1, ',0,1,10006,', 255, 10006, 3),
(10145, 'data_del', '删除供应商到回收站', 1, ',0,1,10006,', 256, 10006, 3),
(10146, 'data_del_todo', '从回收站删除供应商', 1, ',0,1,10006,', 257, 10006, 3),
(10147, 'data_del_undo', '从回收站恢复供应商', 1, ',0,1,10006,', 258, 10006, 3),
(10148, 'data_status_to_y', '批量启用供应商', 1, ',0,1,10006,', 259, 10006, 3),
(10149, 'data_status_to_n', '批量禁用供应商', 1, ',0,1,10006,', 260, 10006, 3),
(10150, 'data_move_byid', '批量转移选中供应商的类别', 1, ',0,1,10006,', 261, 10006, 3),
(10151, 'data_move_byclass', '批量按类别转移到新类别', 1, ',0,1,10006,', 262, 10006, 3),
(10152, 'get_parentstr', '公用读取层级关系', 1, ',0,1,10006,', 264, 10006, 3),
(10153, 'set_parentstr', '公用设置层级关系', 1, ',0,1,10006,', 265, 10006, 3),
(10154, 'get_class_list', '读取类别下拉数据', 1, ',0,1,10006,', 266, 10006, 3),
(10155, 'supplier_popup', '打开供应商弹窗', 1, ',0,1,10006,', 267, 10006, 3),
(10156, 'index', '销售模块首页', 1, ',0,1,10007,', 270, 10007, 3),
(10157, 'so_list', '查看销售单列表', 1, ',0,1,10007,', 271, 10007, 3),
(10158, 'so_add', '新增销售单界面', 1, ',0,1,10007,', 272, 10007, 3),
(10159, 'so_add_save', '新增销售单保存', 1, ',0,1,10007,', 273, 10007, 3),
(10160, 'so_edit', '编辑销售单界面', 1, ',0,1,10007,', 274, 10007, 3),
(10161, 'so_edit_save', '编辑销售单保存', 1, ',0,1,10007,', 275, 10007, 3),
(10162, 'so_save_post', '销售单保存并过账', 1, ',0,1,10007,', 276, 10007, 3),
(10163, 'so_post', '销售单过账', 1, ',0,1,10007,', 277, 10007, 3),
(10164, 'so_write_off', '从销售单生成退货单', 1, ',0,1,10007,', 278, 10007, 3),
(10165, 'rnc_list', '查看退货单列表', 1, ',0,1,10007,', 279, 10007, 3),
(10166, 'rnc_add', '新增退货单界面', 1, ',0,1,10007,', 280, 10007, 3),
(10167, 'rnc_add_save', '新增退货单保存', 1, ',0,1,10007,', 281, 10007, 3),
(10168, 'rnc_edit', '编辑退货单界面', 1, ',0,1,10007,', 282, 10007, 3),
(10169, 'rnc_edit_save', '编辑退货单保存', 1, ',0,1,10007,', 283, 10007, 3),
(10170, 'rnc_save_post', '退货单保存并过账', 1, ',0,1,10007,', 284, 10007, 3),
(10171, 'rnc_post', '退货单过账', 1, ',0,1,10007,', 285, 10007, 3),
(10172, 'doc_check_status', '公用检查单据状态', 1, ',0,1,10007,', 287, 10007, 3),
(10173, 'doc_status_to_a', '批量恢复单据', 1, ',0,1,10007,', 288, 10007, 3),
(10174, 'doc_status_to_c', '批量取消单据', 1, ',0,1,10007,', 289, 10007, 3),
(10175, 'sales_history', '查看销售历史', 1, ',0,1,10007,', 290, 10007, 3),
(10176, 'sales_report', '销售分类汇总', 1, ',0,1,10007,', 291, 10007, 3),
(10177, 'index', '采购模块首页', 1, ',0,1,10008,', 294, 10008, 3),
(10178, 'po_list', '查看采购单列表', 1, ',0,1,10008,', 295, 10008, 3),
(10179, 'po_add', '新增采购单界面', 1, ',0,1,10008,', 296, 10008, 3),
(10180, 'po_add_save', '新增采购单保存', 1, ',0,1,10008,', 297, 10008, 3),
(10181, 'po_edit', '编辑采购单界面', 1, ',0,1,10008,', 298, 10008, 3),
(10182, 'po_edit_save', '编辑采购单保存', 1, ',0,1,10008,', 299, 10008, 3),
(10183, 'po_save_post', '采购单保存并过账', 1, ',0,1,10008,', 300, 10008, 3),
(10184, 'po_post', '采购单过账', 1, ',0,1,10008,', 301, 10008, 3),
(10185, 'po_write_off', '从采购单生成退货单', 1, ',0,1,10008,', 302, 10008, 3),
(10186, 'rns_list', '查看退货单列表', 1, ',0,1,10008,', 303, 10008, 3),
(10187, 'rns_add', '新增退货单界面', 1, ',0,1,10008,', 304, 10008, 3),
(10188, 'rns_add_save', '新增退货单保存', 1, ',0,1,10008,', 305, 10008, 3),
(10189, 'rns_edit', '编辑退货单界面', 1, ',0,1,10008,', 306, 10008, 3),
(10190, 'rns_edit_save', '编辑退货单保存', 1, ',0,1,10008,', 307, 10008, 3),
(10191, 'rns_save_post', '退货单保存并过账', 1, ',0,1,10008,', 308, 10008, 3),
(10192, 'rns_post', '退货单过账', 1, ',0,1,10008,', 309, 10008, 3),
(10193, 'doc_check_status', '公用检查单据状态', 1, ',0,1,10008,', 311, 10008, 3),
(10194, 'doc_status_to_a', '批量恢复单据', 1, ',0,1,10008,', 312, 10008, 3),
(10195, 'doc_status_to_c', '批量取消单据', 1, ',0,1,10008,', 313, 10008, 3),
(10196, 'pur_history', '查看采购历史', 1, ',0,1,10008,', 314, 10008, 3),
(10197, 'pur_report', '采购分类汇总', 1, ',0,1,10008,', 315, 10008, 3),
(10198, 'index', '其他出入库首页', 1, ',0,1,10009,', 318, 10009, 3),
(10199, 'stkin_list', '查看其他入库单列表', 1, ',0,1,10009,', 319, 10009, 3),
(10200, 'stkin_add', '新增其他入库单界面', 1, ',0,1,10009,', 320, 10009, 3),
(10201, 'stkin_add_save', '新增其他入库单保存', 1, ',0,1,10009,', 321, 10009, 3),
(10202, 'stkin_edit', '编辑其他入库单界面', 1, ',0,1,10009,', 322, 10009, 3),
(10203, 'stkin_edit_save', '编辑其他入库单保存', 1, ',0,1,10009,', 323, 10009, 3),
(10204, 'stkin_save_post', '保存并过账', 1, ',0,1,10009,', 324, 10009, 3),
(10205, 'stkin_post', '过账', 1, ',0,1,10009,', 325, 10009, 3),
(10206, 'stkout_list', '查看其他出库单列表', 1, ',0,1,10009,', 326, 10009, 3),
(10207, 'stkout_add', '新增其他出库单界面', 1, ',0,1,10009,', 327, 10009, 3),
(10208, 'stkout_add_save', '新增其他出库单保存', 1, ',0,1,10009,', 328, 10009, 3),
(10209, 'stkout_edit', '编辑其他出库单界面', 1, ',0,1,10009,', 329, 10009, 3),
(10210, 'stkout_edit_save', '编辑其他出库单保存', 1, ',0,1,10009,', 330, 10009, 3),
(10211, 'stkout_save_post', '保存并过账', 1, ',0,1,10009,', 331, 10009, 3),
(10212, 'stkout_post', '过账', 1, ',0,1,10009,', 332, 10009, 3),
(10213, 'whswitch_list', '查看仓库调拨单列表', 1, ',0,1,10009,', 333, 10009, 3),
(10214, 'whswitch_add', '新增仓库调拨单界面', 1, ',0,1,10009,', 334, 10009, 3),
(10215, 'whswitch_add_save', '新增仓库调拨单保存', 1, ',0,1,10009,', 335, 10009, 3),
(10216, 'whswitch_edit', '编辑仓库调拨单界面', 1, ',0,1,10009,', 336, 10009, 3),
(10217, 'whswitch_edit_save', '编辑仓库调拨单保存', 1, ',0,1,10009,', 337, 10009, 3),
(10218, 'whswitch_save_post', '保存并过账', 1, ',0,1,10009,', 338, 10009, 3),
(10219, 'whswitch_post', '过账', 1, ',0,1,10009,', 339, 10009, 3),
(10220, 'doc_check_status', '公用检查单据状态', 1, ',0,1,10009,', 341, 10009, 3),
(10221, 'doc_status_to_a', '批量恢复单据', 1, ',0,1,10009,', 342, 10009, 3),
(10222, 'doc_status_to_c', '批量取消单据', 1, ',0,1,10009,', 343, 10009, 3),
(10223, 'stkio_history', '查看出入库历史', 1, ',0,1,10009,', 344, 10009, 3),
(10224, 'index', '财务模块首页', 1, ',0,1,10010,', 347, 10010, 3),
(10225, 'currmas_list', '查看货币列表', 1, ',0,1,10010,', 348, 10010, 3),
(10226, 'currmas_add', '新增货币界面', 1, ',0,1,10010,', 349, 10010, 3),
(10227, 'currmas_add_save', '新增货币保存', 1, ',0,1,10010,', 350, 10010, 3),
(10228, 'currmas_edit', '编辑货币界面', 1, ',0,1,10010,', 351, 10010, 3),
(10229, 'currmas_edit_save', '编辑货币保存', 1, ',0,1,10010,', 352, 10010, 3),
(10230, 'currmas_del', '删除货币', 1, ',0,1,10010,', 353, 10010, 3),
(10231, 'currmas_status_to_y', '启用货币', 1, ',0,1,10010,', 354, 10010, 3),
(10232, 'currmas_status_to_n', '禁用货币', 1, ',0,1,10010,', 355, 10010, 3),
(10233, 'currmas_popup', '打开货币弹窗', 1, ',0,1,10010,', 356, 10010, 3),
(10234, 'fiscalyp_list', '查看会计期间列表', 1, ',0,1,10010,', 357, 10010, 3),
(10235, 'fiscalyp_add', '新增会计期间', 1, ',0,1,10010,', 358, 10010, 3),
(10236, 'fiscalyp_status_to_0', '关闭会计期间', 1, ',0,1,10010,', 359, 10010, 3),
(10237, 'fiscalyp_status_to_1', '半关会计期间', 1, ',0,1,10010,', 360, 10010, 3),
(10238, 'fiscalyp_status_to_2', '全开会计期间', 1, ',0,1,10010,', 361, 10010, 3),
(10239, 'fiscalyp_check', '检查期间状态', 1, ',0,1,10010,', 362, 10010, 3),
(10240, 'faccmas_list', '查看会计科目列表', 1, ',0,1,10010,', 364, 10010, 3),
(10241, 'faccmas_add', '新增会计科目界面', 1, ',0,1,10010,', 365, 10010, 3),
(10242, 'faccmas_add_save', '新增会计科目保存', 1, ',0,1,10010,', 366, 10010, 3),
(10243, 'faccmas_edit', '编辑会计科目界面', 1, ',0,1,10010,', 367, 10010, 3),
(10244, 'faccmas_edit_save', '编辑会计科目保存', 1, ',0,1,10010,', 368, 10010, 3),
(10245, 'faccmas_del', '删除会计科目', 1, ',0,1,10010,', 369, 10010, 3),
(10246, 'get_faccmas_parentstr', '公用读取层级关系', 1, ',0,1,10010,', 370, 10010, 3),
(10247, 'set_faccmas_parentstr', '公用设置层级关系', 1, ',0,1,10010,', 371, 10010, 3),
(10248, 'get_faccmas_list', '读取科目下拉数据', 1, ',0,1,10010,', 372, 10010, 3),
(10249, 'faccmas_popup', '打开科目弹窗', 1, ',0,1,10010,', 373, 10010, 3),
(10250, 'faccdefault_list', '查看默认科目列表', 1, ',0,1,10010,', 375, 10010, 3),
(10251, 'faccdefault_add', '新增默认科目界面', 1, ',0,1,10010,', 376, 10010, 3),
(10252, 'faccdefault_add_save', '新增默认科目保存', 1, ',0,1,10010,', 377, 10010, 3),
(10253, 'faccdefault_edit', '编辑默认科目界面', 1, ',0,1,10010,', 378, 10010, 3),
(10254, 'faccdefault_edit_save', '编辑默认科目保存', 1, ',0,1,10010,', 379, 10010, 3),
(10255, 'faccdefault_del', '删除默认会计科目', 1, ',0,1,10010,', 380, 10010, 3),
(10256, 'faccdefault_status_to_y', '启用默认科目', 1, ',0,1,10010,', 381, 10010, 3),
(10257, 'faccdefault_status_to_n', '禁用默认科目', 1, ',0,1,10010,', 382, 10010, 3),
(10258, 'vou_list', '查看凭证列表', 1, ',0,1,10010,', 384, 10010, 3),
(10259, 'vou_add', '新增凭证界面', 1, ',0,1,10010,', 385, 10010, 3),
(10260, 'vou_add_save', '新增凭证保存', 1, ',0,1,10010,', 386, 10010, 3),
(10261, 'vou_edit', '编辑凭证界面', 1, ',0,1,10010,', 387, 10010, 3),
(10262, 'vou_edit_save', '编辑凭证保存', 1, ',0,1,10010,', 388, 10010, 3),
(10263, 'vou_save_post', '保存并过账', 1, ',0,1,10010,', 389, 10010, 3),
(10264, 'vou_post', '过账', 1, ',0,1,10010,', 390, 10010, 3),
(10265, 'vou_check_status', '检查凭证状态', 1, ',0,1,10010,', 391, 10010, 3),
(10266, 'vou_status_to_a', '启用凭证', 1, ',0,1,10010,', 392, 10010, 3),
(10267, 'vou_status_to_c', '禁用凭证', 1, ',0,1,10010,', 393, 10010, 3),
(10268, 'vou_write_off', '生成红字凭证', 1, ',0,1,10010,', 394, 10010, 3),
(10269, 'vou_track', '凭证追踪', 1, ',0,1,10010,', 395, 10010, 3),
(10270, 'fa_checkin_list', '查看收款列表', 1, ',0,1,10010,', 396, 10010, 3),
(10271, 'fa_checkin_add', '新增收款界面', 1, ',0,1,10010,', 397, 10010, 3),
(10272, 'fa_checkin_add_save', '新增收款保存', 1, ',0,1,10010,', 398, 10010, 3),
(10273, 'fa_checkin_edit', '编辑收款界面', 1, ',0,1,10010,', 399, 10010, 3),
(10274, 'fa_checkin_edit_save', '编辑收款保存', 1, ',0,1,10010,', 400, 10010, 3),
(10275, 'fa_checkin_save_post', '保存并过账', 1, ',0,1,10010,', 401, 10010, 3),
(10276, 'fa_checkin_post', '过账', 1, ',0,1,10010,', 402, 10010, 3),
(10277, 'facheck_check_status', '检查单据状态', 1, ',0,1,10010,', 403, 10010, 3),
(10278, 'facheck_status_to_a', '启用单据', 1, ',0,1,10010,', 404, 10010, 3),
(10279, 'facheck_status_to_c', '禁用单据', 1, ',0,1,10010,', 405, 10010, 3),
(10280, 'fa_checkout_list', '查看付款列表', 1, ',0,1,10010,', 406, 10010, 3),
(10281, 'fa_checkout_add', '新增付款界面', 1, ',0,1,10010,', 407, 10010, 3),
(10282, 'fa_checkout_add_save', '新增付款保存', 1, ',0,1,10010,', 408, 10010, 3),
(10283, 'fa_checkout_edit', '编辑付款界面', 1, ',0,1,10010,', 409, 10010, 3),
(10284, 'fa_checkout_edit_save', '编辑付款保存', 1, ',0,1,10010,', 410, 10010, 3),
(10285, 'fa_checkout_save_post', '保存并过账', 1, ',0,1,10010,', 411, 10010, 3),
(10286, 'fa_checkout_post', '过账', 1, ',0,1,10010,', 412, 10010, 3),
(10287, 'ap_list', '应付账款列表', 1, ',0,1,10010,', 413, 10010, 3),
(10288, 'ar_list', '应收账款列表', 1, ',0,1,10010,', 414, 10010, 3),
(10289, 'trial_balance', '试算平衡', 1, ',0,1,10010,', 415, 10010, 3),
(10290, 'vou_detail', '科目明细', 1, ',0,1,10010,', 416, 10010, 3),
(10291, 'ar_statement', '客户对账单', 1, ',0,1,10010,', 417, 10010, 3),
(10292, 'ap_statement', '供应商对账单', 1, ',0,1,10010,', 418, 10010, 3);

INSERT INTO `misone_role` (`id`, `name`, `pid`, `status`, `remark`) VALUES
(1, 'base-group', NULL, 1, '基础操作组'),
(2, 'whman', NULL, 1, '仓管'),
(3, 'pur', NULL, 1, '采购'),
(4, 'sales', NULL, 1, '销售'),
(5, 'faman', NULL, 1, '财务');


INSERT INTO `misone_webconfig` (`varname`, `varinfo`, `vargroup`, `vartype`, `varvalue`, `orderid`) VALUES
('MAIL_PASSWORD', '发件人认证码', 'smtp', 'string', 'support1***', 3),
('MAIL_SMTP', 'SMTP服务器', 'smtp', 'string', 'smtp.exmail.sina.com', 1),
('MAIL_USER', '发件人', 'smtp', 'string', 'support@m16888.cn', 2),
('PO2WH_CTRL_FLG', '采购单直接收货', 'other', 'bool', 'Y', 1),
('SO2WH_CTRL_FLG', '销售单直接出货', 'other', 'bool', 'Y', 2),
('TODAY_FA_ACC', '看板中要显示的科目(可用逗号分隔)', 'other', 'string', '1131,2121,2131,1151', 4),
('TODAY_REFRESH_TIME', '看板自动刷新时间(分)', 'other', 'string', '30', 3),
('UPLOAD_ALLOW_EXTS', '允许上传的类型', 'basic', 'string', 'jpg,gif,png,jpeg,bmp,rar,zip,7z,xls,doc,pdf,swf', 12),
('UPLOAD_ALLOW_SIZE', '允许的文件大小', 'basic', 'number', '1024000', 13),
('UPLOAD_PATH', '文件上传路径', 'basic', 'string', '/Public/Upload/', 11),
('UPLOAD_RULE', '文件重命名方式', 'basic', 'string', 'uniqid', 14),
('WEB_LOGO', '公司LOGO', 'basic', 'string', '/Public/Images/ssksoftlogo.png', 3),
('WEB_TITLE', '公司名称', 'basic', 'string', '金秘书-进销存财', 1),
('WEB_URL', '系统URL', 'basic', 'string', 'http://127.0.0.1/', 2),
('WHSWITCH_USE_NEWDATE', '调拨入库的商品使用新日期', 'other', 'bool', 'Y', 5);

INSERT INTO `misone_whmas` (`id`, `title`, `flag`, `keywords`, `diyinfo`, `orderid`, `posttime`, `status_flg`) VALUES
(1, '成品仓', 'default', '', 'N;', 0, 1348891639, 'Y');

";
    
        $querys = explode(';', $tbdata);
		foreach($querys as $q)
		{
			if(trim($q) == '') continue;
			mysql_query(trim($q).';');
		}
		echo '<script>$("#content_area").append("配置导入完成！<br />");</script>';
        
		
		//安装完成进行跳转
		echo '<script>location.href="?s='.md5('done').'";</script>';
	}
	else
	{
		echo '<script>$("#content_area").append("数据库连接错误，请检查！");</script>';
	}
}
?>